/*
CREATE TABLE "base_cost_code" (
  "sequence_nbr" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "type" text(16) NOT NULL,
  "mark_code" text(32),
  "code" text(32) NOT NULL,
  "name" text(255) NOT NULL,
  "province" integer(20),
  "de_standard_id" integer(20),
  "rec_user_code" text(32),
  "rec_status" text(4),
  "rec_date" integer(20),
  "extend1" text(64),
  "extend2" text(64),
  "extend3" text(64),
  "description" text(255),
  "agency_code" text(64),
  "product_code" text(64)
);
         */

use rbatis::crud;
use serde::{Deserialize, Serialize};

#[derive(Debug, Serialize, Deserialize)]
pub struct BaseCostCode {
    pub sequence_nbr: i32,
    pub r#type: String,
    pub mark_code: Option<String>,
    pub code: String,
    pub name: String,
    pub province: Option<i32>,
    pub de_standard_id: Option<i32>,
    pub rec_user_code: Option<String>,
    pub rec_status: Option<String>,
    pub rec_date: Option<i32>,
    pub extend1: Option<String>,
    pub extend2: Option<String>,
    pub extend3: Option<String>,
    pub description: Option<String>,
    pub agency_code: Option<String>,
    pub product_code: Option<String>,
}
crud!(BaseCostCode {}, "base_cost_code");
